home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Fritz: All Fritz
/
All Fritz.zip
/
All Fritz
/
FILES
/
COMMADIO
/
PRODUTIL.LZH
/
STOCK.DOC
< prev
next >
Wrap
Text File
|
1990-09-13
|
4KB
|
80 lines
STOCK.DOC VERSION .04 09/12/90 By W.S. Hillman Jr.
1. Stock.com filters out the stock quote from (the TEXT file that
prodhp makes) with todays date and displays the first one found and
asks for Y/n to process. If answer is N looks for next quote for
today if there is one. If answer is Y or CR then processes it and
puts in file quote.dat. Quote.dat has the stock values converted
from fractions to decimal for spread sheet to import. Super Calc 5
will import as a number file. When asked for part to import reply
with column A:1 to E:x. X=the total number of stocks that you
have. I load them in SC to a unused part of the screen and then move
to the proper place. It also prints the Funds as well. All values
that are missing are replaced by a "0" so the spread sheet will keep
the columns straight. A date such as in funds is converted (10/
24 to 10.24) again so the spread sheet can load as text or number.
A file is needed (stock.dat) of the stocks that you want to collect.
The list can be in any order you want which can be the same as
Prodigy print out or in the order that you may have in you spread
sheet. A stock can be left out as well. Funds have to be marked as
drbdx* with the "*" added so stock.com knows that it is a fund and
treated differently. The plus or minus +- for changes is carried to
the spread sheet as some/all will show in red for minus. The first
line in the stock.dat list is a number and making larger or smaller
determines how many lines are printed. It is 5 now and seems
correct, but the way you print the lists to disk may change the
needed lines. Change the sample stock.dat to your stock list. Place
funds last as they print out in a different format and make sure to
add the (*) or program will treat as stock and give a funny print
out. SC uses the file as is, but other sheets may need to be
converted from text to number in the sheet. Check your spread sheet
manual under importing data. With SC5 I use a simple macro loaded on
sheet that loads the quote.dat and moves to proper place in sheet.
2. The file stock.dat contains your list of stocks plus on the first
line a 5. Making smaller or larger determines how many lines are
printing when hunting today file. IMPORTANT ::: When editing this file
or making new one, use a ascii editor and use CR after each line
including the last line or stock.com cannot read correctly.
On the second line of this file is the name of the file that you want
to use to hunt for stock quotes. Usually is will be the one file you
use for everything but it can be changed to any name you want. It is
now Prodigy.txt
The next lines are the names of your stocks, Now they have mine and
will work with the sample file when its date is changed to todays.
3, There is a sample quote.dat that shows how it should look after
being processed.
4. There is a sample today file that you can see how it works. Change
the date to todays for test in the quote part of print out.
5. Ver. 03 corrects end of file error
6. Ver. 04 added file name selection and no file error trap.
***** SHARE WARE *****
If you find this program useful, a donation would be appreciated.
Both by me and my two cats Susie Q. and Skaters Waltz (keeps them in
treats to lure them out of the computer room, they love the buss
cables)
***** NOTICE!! *****
Any one downloads prodsq04.zip and uploads to a local board please
send me the BB# so I can put on Prodigy
William S. Hillman Jr.
1124 Story Pl.
Alhambra Ca. 91801
ID# MDPP22A
Prodigy is copyright of Sears/Ibm
Prodhp is copyright Pete Davis/Ron Ladne
This utility has not been approved by Prodigy.
Thanks to Herbert Symmers Jr. & Peter Davis who did the beta testing.